Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gsc_sequence table — gscsq

This is a generic sequence number and format table. All entries in this table are system-owned by their nature.

When a sequence number must be generated, it is done at the end of the update as part of the transaction. This table is a potential bottleneck, so locks should be kept to an absolute minimum. Locks during user interaction should be avoided.

If you want sequence numbers to be automatically generated, then there can be no holes in the sequence numbers. For this reason, a standard Progress 4GL sequence is not used.

Example uses for this table are the automatic generation of document numbers or transaction references.

Table 12–1 lists the table’s FLA, fields, and foreign keys.

Table 12–1: gsc_sequence table information 

Table FLA	Fields (data type)	Foreign keys
gscsq	sequence_obj (Decimal) company_organisation_obj (Decimal) owning_entity_mnemonic (Character) sequence_tla (Character) sequence_short_desc (Character) sequence_description (Character) min_value (Integer) max_value (Integer) sequence_format (Character) auto_generate (Logical) multi_transaction (Logical) next_value (Integer) number_of_sequences (Integer) sequence_active (Logical)	sequence_obj

Table 12–2 gives details of the table’s indexes.

Table 12–2: gsc_sequence index information 

Index name	Elements	Type
XPKgsc_sequence	sequence_obj	Primary Unique
XAK1gsc_sequence	company_organisation_obj owning_entity_mnemonic sequence_tla	Unique
XIE1gsc_sequence	sequence_description	Nonunique
XIE2gsc_sequence	sequence_short_desc	Nonunique